HCL
Skip to main content  
 
   


SPRTechnote


Field with 0 Decimal Places Works Differently in Notes 6 than Notes R5

Technote Number: 1107842


Problem:
This issue was reported to Lotus Software Quality Engineering, and was
addressed in Notes/Domino 6.0.1 CF2.


Excerpt from the Lotus Notes and Domino Release 6.0.1 CF2 fix list (available
at http://www.lotus.com/ldd):

Design

SPR# STE5HBULN - Fixed an issue where floating point-to-string formatting did
not correctly round certain numbers (such as 0.9999999 . . .) in fixed-point
formats.

A workaround in Domino 6 Designer / Notes 6 Client is to use the @Round
function within the Input Translation formula of the field:

For example: @Round(<fieldname>)

Steps to reproduce issue:

1. In Domino 6 Designer create a field on a form and set it to be of Type:
Number, Editable.
2. On the Control tab (second tab from the left in the InfoBox which pops up
when the field is created) go to the Decimal Places section and deselect the
Varying checkbox. Set the Fixed decimal place box equal to 0.
3. In the default value event for the field, type in: 20/3
4. Save the form, and preview it in Notes Client (by selecting from the
Domino Designer men: Design, Preview in Notes).

Notes 6 returns the value of 6.
Notes R5 will return the value of 7. Since 20/3 is equal to 6.67, it seems
that Notes 6 is simply chopping off any numbers to the right of the decimal
point, while R5 is using rounding principles to obtain the value of 7. In any
case, this is different from behavior in R5 and could cause a problem with
customer applications.
More >





  Document options
Print this document
Print view

  Search
Search Advanced Search


  Fix list views

 RSS feeds   RSS
Subscribe to the fix list

  Resources
Using this database
View notices

  HCL Support
HCL Support


    About HCL Privacy Contact